import pandas as pd
import random

# 读取原始数据
df = pd.read_csv('LYG2306.csv')

# 伪造厦门的气压数据，在1002 - 1007hPa之间随机生成
new_air_pressure = [random.uniform(1002, 1007) for _ in range(len(df))]
df['Air_Pressure'] = new_air_pressure

# 伪造厦门的海面温度数据，在23 - 28℃之间随机生成
new_sea_temperature = [random.uniform(23, 28) for _ in range(len(df))]
df['Sea_Temperature'] = new_sea_temperature

# 伪造厦门的浪高数据，在0.3 - 2.0米之间随机生成
new_wind_wave_height = [random.uniform(0.3, 2.0) for _ in range(len(df))]
df['Wind_Wave_Height'] = new_wind_wave_height

# 将Station列的值全部改成Xiamen
df['Station'] = 'Xiamen'

# 保存为XMN2305.CSV文件
df.to_csv('XMN2305.CSV', index=False)